Line and stacked column Visual 17

Visual 4: Line and stacked column Visual =: Deaths Per Mth /%YoY, %MoM by Interaction Groups

Fields Tab

For step 1

·         Shared Axis: Interaction Group

·         Column Values: Deaths per Mth

·         Line Values: %YoY, %MoM

Format Tab

·         General: X Position = 757, Y Position = 410, Width = 515, Height = 294

·         Maintain layer order = off

Step 2

Legend: On, Position = Top, Title = on, Color = #00000, font family = Segoe Ui, Text size = 10, Style = Markers Only, Match line color = on, circle defaut icon = on

X Axis: Color = #7777777, Text Size = 9, Font family = Segoe UI, Minimum category width = 20, Maximum Size = 25%, Inner Padding = 20%, Concatenate labels = On, Title = Off

Y Axis: Position = Left, Scale Type = Linear, start = Auto, End = Auto, Invert Axis = off, Color = #000000, Text size = 9, Font family = Segoe UI, Display Units = Auto, Value Decimal places = Auto, Title = Off, Grid line = on, Line color = #CCCCCC, Strok width = 1, Line style = Doted, Show secondary = on, Aline zeros = off

 

Step 3

 Zoom Slider = off

Data Colors, YoY% = #E1A204, MoM = #33DBFF, Show all = off, (Color = #000000)

 Data Label = On, Color = #000000, Display Units = Auto, Value Decimal places = 2, Orientation = Horizontal, Position = Auto, Text Size = 9, Font Family = DIN, Show Background = on, Background color = #FFFFFF, Transparency = 0%, Customize series = off

Shapes: Shade area = On, Stroke width = 3, Join Type = Round, Line Style = Solid, show marker = off, stepped = off, customize series = off,

Plot Area: Transparency = 50%

 

Step 4

Title = On, Text = By Interaction Group, Title Heading = Heading 3; Word wrap = On, font color = #FFFFFF, Background color = #000000, Alignment = Center, Text Size = 15, Font Family = Segoe UI

Background: On, color = #FFFFFF, Transparency = 0%

Lock Aspect = off

 Border: off

Shadow: Off

Tooltip = On, Type = Report Page, Page = Auto, Label Text color = #000000, Value text color = #EAEAEA, Text size = 9, Font family = Segoe UI, Background color = #333333, Transparency = 5%

Visual header = On, background color = #FFFFFF, Boarder = #FFFFFF, Transparency = 0%, Icon color = #333333, Visual information icon = On, Visual warning icon = On, Visual error icon = on, Drill on drop down = On, Drill up icon = On, Drill down icon = On, Show next level icon = On, Expand to next level icon = On, Expand to next level icon = on, Pin icon = On, Focus mode icon = On, Filter icon = On, See data layout icon = On, More Options icon = On, Visual Header tooltip icon = off

 

Step 5

Select “Filter” From “View” menu then in Filter click “Interaction Group” then select the following Interaction Group type::

 


 

Use the following step by step Gif to create the visual

For step 1


For step 2


For step 3


For step 4


For step 5


Line and Stacked Column Chart in Power BI

https://www.tutorialgateway.org/line-and-stacked-column-chart-in-power-bi/